SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

/****** Objeto: vista dbo.wav_tracking    fecha de la secuencia de comandos: 02/11/2005 18:17:52 ******/

CREATE  VIEW [dbo].[wav_tracking] AS 

SELECT
	track.fe_operacion,
	track.cd_operador,
	oper.nm_operador,
	track.nm_programa,
	prog.de_programa,
	track.nm_tabla,
	tablas.de_tabla,
	track.tp_operacion,
	track.nm_terminal,
	track.de_operacion
FROM
	wap_tracking AS track
	JOIN wad_operadores AS oper ON track.cd_operador = oper.cd_operador
	JOIN wad_programas AS prog ON track.nm_programa = prog.nm_programa
	JOIN wad_tablas AS  tablas ON track.nm_tabla = tablas.nm_tabla




GO
